//
//  DataAccess.h
//  Pitch
//
//  Created by zhujinhui on 14-9-7.
//  Copyright (c) 2014年 zhujinhui. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>

@interface DataAccess : NSObject


//+(DataAccess *) shareInstance;

/**
 * this
 */
//-(NSString *)databaseName;


-(NSString *)databasePath;


-(void)execSql:(NSString *)sql;

-(NSArray *)selectTable:(NSString *)table atRow:(const int)row;

-(NSString *) selectOneFromTable:(NSString *)table withDictionary:(NSDictionary *)dic;

-(NSArray *) selectAllFromTable:(NSString *)table withDictionary:(NSDictionary *)dic;

-(NSString *) selectOneCityFromTable:(NSString *)table withDictionary:(NSDictionary *)dic;

-(NSArray *) selectAllZonesFromTable:(NSString *)table withDictionary:(NSDictionary *)dic;

@end
